package com.ruoyi.system.mapper;

import java.util.HashMap;
import java.util.List;
import com.ruoyi.system.domain.AdminUserBetRecord;
import org.apache.ibatis.annotations.Param;

/**
 * 用户投注记录Mapper接口
 *
 * @author ruoyi
 * @date 2020-11-06
 */
public interface AdminUserBetRecordMapper
{
    /**
     * 查询用户投注记录
     *
     * @param id 用户投注记录ID
     * @return 用户投注记录
     */
    public AdminUserBetRecord selectAdminUserBetRecordById(Long id);

    public List<AdminUserBetRecord> selectAdminUserBetRecordByPeriod(Long period);

    public List<AdminUserBetRecord> selectAdminUserBetRecordByPeriodAndRoom(AdminUserBetRecord adminUserBetRecord);

    public AdminUserBetRecord selectAdminUserBetRecordByPeriodAndRoomAndCommand(AdminUserBetRecord adminUserBetRecord);

    public List<AdminUserBetRecord> selectLuckUserBetRecord(AdminUserBetRecord adminUserBetRecord);

    public List<AdminUserBetRecord> selectLuckUserBetRecordAndNotRoot(AdminUserBetRecord adminUserBetRecord);

    public List<AdminUserBetRecord> selectAdminUserBetRecordByPeriodAndRoomInfo(AdminUserBetRecord adminUserBetRecord);
    public List<HashMap<String,Object>> selectAdminUserBetRecordGroupByPayNum(AdminUserBetRecord adminUserBetRecord);

    public Double selectSumPriceByPeriodAndRoom(AdminUserBetRecord adminUserBetRecord);

    public Double selectLuckSumPrice(AdminUserBetRecord adminUserBetRecord);


    public Double selectSumPriceByPeriodAndRoomAndWexinId(AdminUserBetRecord adminUserBetRecord);

    public Double selectAllSumPriceByPeriodAndRoom(AdminUserBetRecord adminUserBetRecord);
    /**
     * 查询用户投注记录列表
     *
     * @param adminUserBetRecord 用户投注记录
     * @return 用户投注记录集合
     */
    public List<AdminUserBetRecord> selectAdminUserBetRecordList(AdminUserBetRecord adminUserBetRecord);

    public List<AdminUserBetRecord> selectAdminUserBetRecordListByRoomAndPeriod(@Param("room") String room,@Param("period") Long period);

    public List<AdminUserBetRecord> selectAdminUserBetRecordListForAdmin(AdminUserBetRecord adminUserBetRecord);

    /**
     * 新增用户投注记录
     *
     * @param adminUserBetRecord 用户投注记录
     * @return 结果
     */
    public int insertAdminUserBetRecord(AdminUserBetRecord adminUserBetRecord);

    /**
     * 修改用户投注记录
     *
     * @param adminUserBetRecord 用户投注记录
     * @return 结果
     */
    public int updateAdminUserBetRecord(AdminUserBetRecord adminUserBetRecord);

    /**
     * 删除用户投注记录
     *
     * @param id 用户投注记录ID
     * @return 结果
     */
    public int deleteAdminUserBetRecordById(Long id);

    public int deleteAdminUserBetRecordByRoomAndPeriod(@Param("room") String room,@Param("period") Long period);

    /**
     * 批量删除用户投注记录
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteAdminUserBetRecordByIds(Long[] ids);
}
